package com.cy.detectsys.mapper;

import com.cy.detectsys.entity.DbWidePing;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author admin
* @description 针对表【db_wide_ping】的数据库操作Mapper
* @createDate 2024-05-11 23:19:06
* @Entity com.cy.detectsys.entity.DbWidePing
*/
public interface DbWidePingMapper extends BaseMapper<DbWidePing> {

    List<String> selectIps(List<String> subdomains);

    @Select("\tSELECT distinct ky_ed_wide_ping_ip FROM `detect`.`db_wide_ping` WHERE `ky_ed_wide_ping_sudomain` = #{subdomain} and ky_ed_wide_ping_ip is not null limit 1\n")
    String selectIpbySubdomain(String subdomain);
}




